hpv_targets

Table: hpv_targets

The hpv_targets table stores vaccination targets assigned to each vaccinator for different delivery types.
It helps track performance goals for fixed sites, community outreach, and school campaigns.

---

Columns

Column Name	Data Type	Constraints	Description
vaccinatorId	int(11)	NOT NULL, PRIMARY KEY, UNIQUE	ID of the vaccinator (references user.mappedId)
fixed	decimal(10,2)	NOT NULL	Target number of vaccinations at fixed sites
community	decimal(10,2)	NOT NULL	Target number of vaccinations in the community
school	decimal(10,2)	NOT NULL	Target number of vaccinations at schools

---

Indexes

1. PRIMARY - Primary key on vaccinatorId
2. UNIQUE - mappedId_UNIQUE on vaccinatorId

---

Foreign Key Relations

• None explicitly defined, but vaccinatorId typically references user.mappedId.

---

Usage Notes

• Used to assign vaccination targets to vaccinators for planning and reporting.
• Supports tracking performance across different delivery channels: fixed, community, and school.
• Unique constraint ensures each vaccinator has only one target record.